MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

48 rows where Artist Alpha Sort = 5417

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Highlight, Object Name, Title, Object Date, Object Begin Date, Object End Date, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
66856 66856 1997.59.21 0 0 79444 Costume Institute 8 Maillot 5878 Maillot American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 probably late 1980s 1985 1989 cotton/polyester 15242   Gift of the Estate of Luciana Martinez de la Rosa, 1997                           http://www.metmuseum.org/art/collection/search/79444 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
66859 66859 1997.59.24 0 0 79447 Costume Institute 8 Jeans 5905 Jeans American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1980–89 1980 1989 cotton 3340   Gift of the Estate of Luciana Martinez de la Rosa, 1997                           http://www.metmuseum.org/art/collection/search/79447 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
67871 67871 1998.164.1a, b 0 0 80600 Costume Institute 8 Ensemble 5875 Ensemble American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 early 1970s 1970 1975 silk 15101   Purchase, Gifts from Various Donors, 1998                           http://www.metmuseum.org/art/collection/search/80600 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
68126 68126 1998.503.2 0 0 80898 Costume Institute 8 Coat 4973 Coat American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 fall/winter 1984–85 1984 1985 cotton 3340   Gift of Dorothy Schroepfer in memory of Dr. Jacqueline Nancy Rector from her collection, 1998                           http://www.metmuseum.org/art/collection/search/80898 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
68127 68127 1998.504.2 0 0 80900 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1968–78 1968 1978 synthetic 15169   Gift of Barbara Wexner Levy, 1998                           http://www.metmuseum.org/art/collection/search/80900 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
68325 68325 1978.163.1a–d 0 0 81129 Costume Institute 8 Jumpsuit 5956 Jumpsuit American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1977 1977 1977 silk, nylon, plastic 15558   Gift of Eddie Kamali, 1978                           http://www.metmuseum.org/art/collection/search/81129 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
68345 68345 1993.517.36 0 0 81151 Costume Institute 8 Skirt 1152 Skirt American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1970s 1970 1979 wool 15104   Gift of Jane Holzer, 1993                           http://www.metmuseum.org/art/collection/search/81151 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
68625 68625 1978.163.2a–c 1 0 81453 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1977 1977 1977 silk, nylon, cotton 15679   Gift of Eddie Kamali, 1978                           http://www.metmuseum.org/art/collection/search/81453 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
69969 69969 2002.199.23a, b 0 0 83792 Costume Institute 8 Shoes 5896 Shoes American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1982 1982 1982 leather, synthetic 15765   Gift of Muriel Kallis Newman, 2002                           http://www.metmuseum.org/art/collection/search/83792 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
70477 70477 1978.163.3 0 0 84447 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1977 1977 1977 silk, nylon 15681   Gift of Eddie Kamali, 1978                           http://www.metmuseum.org/art/collection/search/84447 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
70478 70478 1978.163.4a–d 0 0 84448 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1977 1977 1977 a) nylon b) silk c) nylon d) plastic 16231   Gift of Eddie Kamali, 1978                           http://www.metmuseum.org/art/collection/search/84448 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72094 72094 2003.359.2 0 0 87515 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1974 1974 1974 polyester 15163   Gift of Norma Kamali, 2003                           http://www.metmuseum.org/art/collection/search/87515 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72141 72141 2003.71a, b 0 0 87893 Costume Institute 8 Ensemble 5875 Ensemble American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 designed 1980, made 2002 1980 2002 a,b) cotton 16574   Gift of Norma Kamali OMO Norma Kamali, Inc, 2002                           http://www.metmuseum.org/art/collection/search/87893 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72171 72171 2003.79.1 0 0 87946 Costume Institute 8 Scarf 1153 Scarf American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1970s 1970 1979 silk, plastic 15181   Gift of Muriel Kallis Newman, 2003                           http://www.metmuseum.org/art/collection/search/87946 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72177 72177 2003.79.7 0 0 87954 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1978 1978 1978 silk 15101   Gift of Muriel Kallis Newman, 2003                           http://www.metmuseum.org/art/collection/search/87954 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72178 72178 2003.79.8a, b 0 0 87955 Costume Institute 8 Ensemble 5875 Ensemble American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1978 1978 1978 a,b) silk 16216   Gift of Muriel Kallis Newman, 2003                           http://www.metmuseum.org/art/collection/search/87955 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72180 72180 2003.79.10a, b 0 0 87957 Costume Institute 8 Ensemble 5875 Ensemble American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1978 1978 1978 a,b) silk jersey 16591   Gift of Muriel Kallis Newman, 2003                           http://www.metmuseum.org/art/collection/search/87957 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72195 72195 2003.79.26 0 0 87984 Costume Institute 8 Jacket 4399 Jacket American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1980 1975 1985 nylon 15130   Gift of Muriel Kallis Newman, 2003                           http://www.metmuseum.org/art/collection/search/87984 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72196 72196 2003.74.2 0 0 87990 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1988 1983 1993 nylon/lycra blend 16599   Gift of Tina S. Perlmutter, 2003                           http://www.metmuseum.org/art/collection/search/87990 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72197 72197 2003.74.7 0 0 87991 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1990 1985 1995 nylon/lycra, polyester 16600   Gift of Tina S. Perlmutter, 2003                           http://www.metmuseum.org/art/collection/search/87991 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72299 72299 2003.359.1a, b 0 0 88360 Costume Institute 8 Bathing Suit 6190 "Goddess String Bikini" American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1989–90 1989 1990 a,b) polyester 16636   Gift of Norma Kamali, 2003                           http://www.metmuseum.org/art/collection/search/88360 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74420 74420 1980.336.4a–c 0 0 94788 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1978 1973 1983 nylon 15130   Gift of Anne Byrne, 1980                           http://www.metmuseum.org/art/collection/search/94788 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74421 74421 1989.375.11a–c 0 0 94789 Costume Institute 8 Ensemble 5875 Ensemble American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1978–85 1978 1985 nylon, wool (?), Lurex 16980   Gift of Gregory R. Reynolds, 1989                           http://www.metmuseum.org/art/collection/search/94789 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74422 74422 1989.375.12a–c 0 0 94790 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1978–85 1978 1985 silk 15101   Gift of Gregory R. Reynolds, 1989                           http://www.metmuseum.org/art/collection/search/94790 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74423 74423 1986.194.7 0 0 94791 Costume Institute 8 Jacket 4399 Jacket American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1982 1977 1987 cotton 3340   Gift of Barbara and Gregory Reynolds, 1986                           http://www.metmuseum.org/art/collection/search/94791 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74424 74424 1986.194.8 0 0 94792 Costume Institute 8 Miniskirt 6276 Miniskirt American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1982 1977 1987 synthetic 15169   Gift of Barbara and Gregory Reynolds, 1986                           http://www.metmuseum.org/art/collection/search/94792 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74425 74425 1986.248.2 0 0 94793 Costume Institute 8 Bodysuit 5932 Bodysuit American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1982 1982 1982 cotton, polyester, lycra blend 16981   Gift of Barbara and Gregory Reynolds, 1986                           http://www.metmuseum.org/art/collection/search/94793 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74426 74426 1980.336.3 0 0 94794 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1978 1978 1978 nylon 15130   Gift of Anne Byrne, 1980                           http://www.metmuseum.org/art/collection/search/94794 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75175 75175 1987.322.6 0 0 96313 Costume Institute 8 Shoulder bag 6094 Shoulder bag American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1982 1977 1987 python 17103   Gift of Barbara and Gregory Reynolds, 1987                           http://www.metmuseum.org/art/collection/search/96313 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75454 75454 1987.265 0 0 96815 Costume Institute 8 Jacket 4399 Jacket American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1970–71 1970 1971 leather, synthetic, reptile skin 17140   Gift of Dianne E. Graf-Berman, 1987                           http://www.metmuseum.org/art/collection/search/96815 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75455 75455 1987.322.3a–e 0 0 96816 Costume Institute 8 Coat 4973 Coat American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1970 1965 1975 nylon, feathers 17141   Gift of Barbara and Gregory Reynolds, 1987                           http://www.metmuseum.org/art/collection/search/96816 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75456 75456 1987.52.1 0 0 96817 Costume Institute 8 Jacket 4399 Jacket American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1981 1977 1987 leather 15128   Gift of Barbara and Gregory Reynolds, 1987                           http://www.metmuseum.org/art/collection/search/96817 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
77137 77137 1987.322.4 0 0 100776 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1982 1977 1987 leather 15128   Gift of Barbara and Gregory Reynolds, 1987                           http://www.metmuseum.org/art/collection/search/100776 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
79283 79283 1986.187.2 0 0 106224 Costume Institute 8 Jacket 4399 Jacket American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1972 1967 1977 synthetic, elastic 17711   Gift of Brooks Adams, in memory of Paul M. Ettesvold, 1986                           http://www.metmuseum.org/art/collection/search/106224 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
81997 81997 2005.130.2 0 0 112851 Costume Institute 8 Shawl 1281 Shawl American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1980s 1980 1989 silk, sequins 15724   Gift of Muriel Kallis Newman, 2005                           http://www.metmuseum.org/art/collection/search/112851 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
87936 87936 2005.412.1 0 0 127638 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 last quarter 20th century 1975 1999 wool, synthetic 15335   Gift of Jane B. Holzer, 2005                           http://www.metmuseum.org/art/collection/search/127638 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
87937 87937 2005.412.2 0 0 127639 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 last quarter 20th century 1975 1999 synthetic 15169   Gift of Jane B. Holzer, 2005                           http://www.metmuseum.org/art/collection/search/127639 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
88661 88661 2007.170.8 0 0 137308 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1982 1977 1987 leather, metal, cotton 18499   Gift of Muriel Kallis Newman, 2007                           http://www.metmuseum.org/art/collection/search/137308 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
89550 89550 2009.76a, b 0 0 149757 Costume Institute 8 Coat 4973 Coat American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1972–73 1972 1973 synthetic 15169   Purchase, Gould Family Foundation Gift, in memory of Jo Copeland, 2009                           http://www.metmuseum.org/art/collection/search/149757 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91767 91767 2009.300.2924a–c 0 0 157804 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1985 1983 1987 cotton 3340   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1986                           http://www.metmuseum.org/art/collection/search/157804 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97885 97885 2009.300.8248a–c 0 0 175266 Costume Institute 8 Shirt 5887 Shirt American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1985 1983 1987 Cotton  19834   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1986                           http://www.metmuseum.org/art/collection/search/175266 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
98018 98018 2009.300.8395a, b 0 0 175399 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1980 1978 1982 Cotton 2154   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Trapnell Marino, 1995                           http://www.metmuseum.org/art/collection/search/175399 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
98019 98019 2009.300.8396a, b 0 0 175400 Costume Institute 8 Shirtdress 6191 Shirtdress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1980 1978 1982 Cotton 2154   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Trapnell Marino, 1995                           http://www.metmuseum.org/art/collection/search/175400 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
98033 98033 2009.300.8417a–c 0 0 175414 Costume Institute 8 Beachwear 5881 Beachwear American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1980 1978 1982 Synthetic 19874   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Barbara Jakobson, 1998                           http://www.metmuseum.org/art/collection/search/175414 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
98034 98034 2009.300.8418a, b 0 0 175415 Costume Institute 8 Suit 5876 Suit American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 ca. 1980 1978 1982 Wool 2116   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Barbara Jakobson, 1998                           http://www.metmuseum.org/art/collection/search/175415 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
98392 98392 2009.300.8416a, b 0 0 175880 Costume Institute 8 Cocktail dress 6005 Cocktail dress American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1980 1980 1980 Leather 732   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Barbara Jakobson, 1998                           http://www.metmuseum.org/art/collection/search/175880 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
391614 391614 2014.144 0 0 643580 Costume Institute 8 Coat 4973 Coat American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1989–93 1989 1993 silk 15101   Purchase, Gould Family Foundation Gift, in memory of Jo Copeland, 2014                           http://www.metmuseum.org/art/collection/search/643580 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
391617 391617 2014.145 0 0 643584 Costume Institute 8 Coat 4973 Coat American 1         Designer 5   Norma Kamali American, born 1945   Kamali Norma 5417 American 1 1945 2045 1989–93 1989 1993 silk 15101   Purchase, Gould Family Foundation Gift, in memory of Jo Copeland, 2014                           http://www.metmuseum.org/art/collection/search/643584 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 123.034ms · Data license: CC0 · Data source: metmuseum/openaccess